UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJRr3VPECEej9HbXLOIbotukQegTCf4THA/iKXrpDeU='
WHERE
key_id = '0ccfdf2b0b7fdaab2724e1676bbef5bf1fe0b04575de84b39a2500c30f63286f'
AND (
token = 'zJRr3VPECEej9HbXLOIbotukQegTCf4THA/iKXrpDeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)