SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '97955e02230f6326b1045329bca913b2d3d78319983a2868dea1b48db0fead5c' 
  AND token = 'Ep3AomfdFmAbFsmCafvv/cMsL/fNGA3ZdLgbPPn6NXU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00041

JSON explain

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