UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kV5X6QTH955avbG6s4y+6itnVoXyESo301j936XHuEE=' 
WHERE 
  key_id = 'aad13a8f9cd8e3b1f50c63f7e987e8c1ad878003c463e8e535292dbafaf3855e' 
  AND (
    token = 'kV5X6QTH955avbG6s4y+6itnVoXyESo301j936XHuEE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037