UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KMCm6w14CtjJ/Xds8MVb4HGa6UsaZPfFDORGK7qnse4='
WHERE
key_id = '919f90f3182380684860a1489a8cbe00527fd2fb73d6bdd42cfe5bc1b1899289'
AND (
token = 'KMCm6w14CtjJ/Xds8MVb4HGa6UsaZPfFDORGK7qnse4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)