UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'REVWNs6vNGOIe2MRqhvXLieu/EdvSkUgakDWSRmhpaM='
WHERE
key_id = 'cd79d2510e59fc552b351236fa8cd96f4fb9d9872d1f5d0e4a60cb1617dd4ba7'
AND (
token = 'REVWNs6vNGOIe2MRqhvXLieu/EdvSkUgakDWSRmhpaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)