UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8Zv69nZUb5J372us2YNjA36htLKOBl1e03mpmUMRIA='
WHERE
key_id = 'a685c3fc14315866f9ae989da37e21275ce997b437095554ec2bb701fbe49b66'
AND (
token = 'C8Zv69nZUb5J372us2YNjA36htLKOBl1e03mpmUMRIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)