UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'f8WtHA3j2wPNMul1hFlpAE1/fy3SRsq6u3iX+7+Fc9k=' 
WHERE 
  key_id = '052e6849d5d4f1e95328f3e15ea0deeeb54cbcd80c4a22e88383442b53ed6b68' 
  AND (
    token = 'f8WtHA3j2wPNMul1hFlpAE1/fy3SRsq6u3iX+7+Fc9k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032