SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '00d7faaf372270101ee0188b2ddfbb847fdff9294a05cdb016bff9c4db7ae384' 
  AND token = '79y3ec+hN1N1Akrxx/uY0O5mp/Uly+Tu2GBBf4icTvI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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