UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKwTd3kwntTN+ejA+sccKjeZSyP0mH1TGNiCNFVNnpU='
WHERE
key_id = 'c25f125f0833df564bf11970d2e8f5d377d14f5c7a1b2214b98726146a03ee07'
AND (
token = 'cKwTd3kwntTN+ejA+sccKjeZSyP0mH1TGNiCNFVNnpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)