UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '299M8QwEOgGd1yMW/OHHSnc75noITPwkf57X/hI3JlI='
WHERE
key_id = 'c41f92a35f48711a7af041070669e939cacfb2ba1baa4a0b85acc5984a19fbb8'
AND (
token = '299M8QwEOgGd1yMW/OHHSnc75noITPwkf57X/hI3JlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)