SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f7084ea7ac202bfef89ae78e1dc95fce79f28f8788ee88b2b16463621e2ad4a0' 
  AND token = 'hKKpm4QmwDJp/jJ4mU51OKqxQ5FvcDLx7iiuWwU0upA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}