UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FpfK/sZNH5IjSkxjZF9BTe+XF15bvD9T+ERsYabOhMo=' 
WHERE 
  key_id = '8703ea06b9bb62c29bbe6d4850e81e0772aa6a70b8de91bf3c2e6cbec42ea9c0' 
  AND (
    token = 'FpfK/sZNH5IjSkxjZF9BTe+XF15bvD9T+ERsYabOhMo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032