UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LoJRQPYN5PFZD3CbnU8p5he49+um5hA2oKhYqTCW6r4='
WHERE
key_id = '4ef58be226f2a75aded17e1bad20b8d4d43323ee65157d804ffb2319a4d4d32a'
AND (
token = 'LoJRQPYN5PFZD3CbnU8p5he49+um5hA2oKhYqTCW6r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)