UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LWkP0yEesCutxAEWobwCD8nAAha5/hTWatfv6TPCxhc='
WHERE
key_id = 'e2aebc167078ca003160aed327e46e2b4d5e6a434df0240ac92e19f985d7d84f'
AND (
token = 'LWkP0yEesCutxAEWobwCD8nAAha5/hTWatfv6TPCxhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)