SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2c4bcff4fe5e5786bce9f1128a1a6ae3e87e3b49bdead6341318c41f0f74ee47' 
  AND token = 'S/EOsSpMP1WobM1IPLFiIZdsM9Y+Z2sut4C2ThsqJMQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

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