UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zq7DzzAIBDFniZhKYSzvRy5nWSDOLpmQvtYnLrjyEgc='
WHERE
key_id = 'ffb49d6ae372e7dfbbc5dbffa5dfa95110092acf8686d500223f0608a5496b8c'
AND (
token = 'zq7DzzAIBDFniZhKYSzvRy5nWSDOLpmQvtYnLrjyEgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)