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