UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qpGtM7MPqohn2dhz8wu6QEfgh4kcqZp/EhMzddirAPM='
WHERE
key_id = '8bf7c9be29fdbcc72e3717b07a6c4d7018111b5b770183d682abc9479ab2b500'
AND (
token = 'qpGtM7MPqohn2dhz8wu6QEfgh4kcqZp/EhMzddirAPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)