UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HcnKYe7RZ3sLNP/sbwTFW43DqRPYSaA3tbLwHIkO38='
WHERE
key_id = '47316b52848113abba6b4b2493b296da8f1a51987ac206971fa41ded68ae1793'
AND (
token = '4HcnKYe7RZ3sLNP/sbwTFW43DqRPYSaA3tbLwHIkO38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)