UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QkFFNqHceJNg+7EVM96ermWdDdxz6Z9iRBMnladvK7s='
WHERE
key_id = 'fc9b58f7f94da3adf2016ea8a1f876184d785dd53dc67f077c463f39412ce7c7'
AND (
token = 'QkFFNqHceJNg+7EVM96ermWdDdxz6Z9iRBMnladvK7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)