UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mHP5XF5cXF9KrqotFrcOBn8XVMPJmHDYdI4zx0JbecQ='
WHERE
key_id = '560ffe0a5e7f2ff0c894475aca3444dc8d158852a7f395e110d3417ef38be39f'
AND (
token = 'mHP5XF5cXF9KrqotFrcOBn8XVMPJmHDYdI4zx0JbecQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)