UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CjMNVAcsoPy+gFjYqAdd0B/iME4vV9uI6ghCiIzTHtc='
WHERE
key_id = 'f7a585e991a9e92dd2dc408aa6d1683e04a5aad7c59bc522ad32edda9de51b92'
AND (
token = 'CjMNVAcsoPy+gFjYqAdd0B/iME4vV9uI6ghCiIzTHtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)