UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CLBJfwnPGnZRPF8a6P4bG0oyEe8prWREhYahK2rEGTE='
WHERE
key_id = '6dfea35f924fbec001914b40ce7e37788c850cb827265bb532bff80ce00d924b'
AND (
token = 'CLBJfwnPGnZRPF8a6P4bG0oyEe8prWREhYahK2rEGTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)