UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNjH77+Sgeavxx/p4CJ524OSNAvfgbnc52QpuX4+u5c='
WHERE
key_id = '696a24bd906b881342a734ee1c13db1de578a22ecc6ea9abf836c93bfcf9f93e'
AND (
token = 'GNjH77+Sgeavxx/p4CJ524OSNAvfgbnc52QpuX4+u5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)