SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '102bc14253dd5a48a220c7b8b0d12f90a66b7a5be6f3412ac5784521cf9868e7' 
  AND token = '5CqJ5Iyi2Isbivy04O7d44V3zssGI9X+XAUY/Z1ksNc=' 
  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"
    }
  }
}