UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qmp3tczX9ih04ZZ2AnG/Kkq7G4/qEFdK/1iFeQj/LW0='
WHERE
key_id = '9e96772f8146b8a526affbae53d38b185b5f21e07ae197b5c30fe2072c71c1fc'
AND (
token = 'Qmp3tczX9ih04ZZ2AnG/Kkq7G4/qEFdK/1iFeQj/LW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)