UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8YzGVZZLKN+YmXfmg8ZVxhBcyxeJYqLkxPTdRDe02M='
WHERE
key_id = '6c2faa8909237a600b86ae76a374bbd6696e366bb8c9acf2d724040462d32a1d'
AND (
token = '/8YzGVZZLKN+YmXfmg8ZVxhBcyxeJYqLkxPTdRDe02M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)