UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TH4zcGf5TwLH0N6ZJA6L7NbZG2Ls/nNfSLn0hAwBA64='
WHERE
key_id = 'a98ed929da4066476c81359fc0b9de82120c437c63c5a2829b142ce0ddc0e050'
AND (
token = 'TH4zcGf5TwLH0N6ZJA6L7NbZG2Ls/nNfSLn0hAwBA64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)