UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z4gsv5oi4l4N9iqvzq5zLVPS7yvSTZoy4q8SWNok7yU='
WHERE
key_id = '7fb4e263f8117dd0c528ec4747d2e585b6e84e9d60c03adb9fbb5a7799436d0f'
AND (
token = 'Z4gsv5oi4l4N9iqvzq5zLVPS7yvSTZoy4q8SWNok7yU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)