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