UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lP4X3u3MVAbBPEJyNXkf5kHP85UFO+zDvieAGB5DwiE='
WHERE
key_id = '149a011891c381c4e1bc6ad9294749abe466a90d48df2f52d72a8a56179a8a5f'
AND (
token = 'lP4X3u3MVAbBPEJyNXkf5kHP85UFO+zDvieAGB5DwiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)