SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '00bf271d2d46ee7309602f646682e407e2538a236404a54693ce4ff6f972ecbb' 
  AND token = 'EglD+VMg+BDjBE1LR5k/iMSk3H59ekgKieRyJMu7Els=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}