UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3CIRDjhpkZusNnbzX21QZCuTXKa3RWh+sC2dr3otatM='
WHERE
key_id = '7be5fe9ef6e5af7c8662fd011b026a01fa8994d881e6375adcc7fe162b68d00e'
AND (
token = '3CIRDjhpkZusNnbzX21QZCuTXKa3RWh+sC2dr3otatM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)