UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzBDHUHt8ZpjJ9rIAXYxn8arb+oDPP0Z3lQpowx3kIc='
WHERE
key_id = '7ce8812aab85131fd8f42b5e2def25840e44867d4b7e542ab5c589e333cdc1f7'
AND (
token = 'pzBDHUHt8ZpjJ9rIAXYxn8arb+oDPP0Z3lQpowx3kIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)