UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0526JtFWx67Zar8QT0ZLkoun5Aj9zvr9H+RNvpSCG54='
WHERE
key_id = '6cfcf1b0824dce2cfc67d8617ae7faed8a0a19b52b5e3f901a1a275a6c09e79e'
AND (
token = '0526JtFWx67Zar8QT0ZLkoun5Aj9zvr9H+RNvpSCG54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)