UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Onkd29xMRpACnUvYAtYB2+htsIY3buBD9i/QKoV4518='
WHERE
key_id = 'ff8cf8e5b80ac0423b6152bc7ed12ffe44bd619d87e03d594adad4add50f40d1'
AND (
token = 'Onkd29xMRpACnUvYAtYB2+htsIY3buBD9i/QKoV4518='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)