UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmJkCpJR8peDr4sy0vpBCm65PFCi5Ggyqt7ch7tKX54='
WHERE
key_id = '314d1a546a3428d0cde9c9b5ca1da9b050481d82907f49a8e335c94a75abcef0'
AND (
token = 'SmJkCpJR8peDr4sy0vpBCm65PFCi5Ggyqt7ch7tKX54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)