UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Aicrk4eaD0g3Co/DS7ZQgnEeOII1cqteRI1r4msqN8='
WHERE
key_id = '4ba737455e7d2deba15f8c096ffe644f8a1301b78396d293557a8f80a2b3b338'
AND (
token = '8Aicrk4eaD0g3Co/DS7ZQgnEeOII1cqteRI1r4msqN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)