SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3aec0c9fb83b8991733df7113376845c97c0d96d11d423958492546adc3179c7' 
  AND token = 'dgWVPI/97GECK0dvPV2Bu2Qe07fbD6llq96SX3YDz9Y=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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