UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tAcHZryk1E5ReIL77Vc6AW1msSvK3sFCjxX3kMsyjtY='
WHERE
key_id = '9f0405aff3b47bb98c964299b40a349f09cc2aae2109526ad5c707eb0389809a'
AND (
token = 'tAcHZryk1E5ReIL77Vc6AW1msSvK3sFCjxX3kMsyjtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)