UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mfOnTvgdYiBcscxoQvfclEnR1qljt7sUcgYLVNvZark='
WHERE
key_id = '92f4f99897a1604439e4d395a431c72725acd4580976cf6f82d1afe48fe8cd7a'
AND (
token = 'mfOnTvgdYiBcscxoQvfclEnR1qljt7sUcgYLVNvZark='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)