UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzEkbLLHpAa+/ryD7tfGhcwe7EPJuUsYxexW6m/+ODg='
WHERE
key_id = 'f0febbfac4598a90a3b0efe3871090e9d5c120959d230ed5be6f1cd0d4f027f4'
AND (
token = 'XzEkbLLHpAa+/ryD7tfGhcwe7EPJuUsYxexW6m/+ODg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)