SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '46c67e497ee3431ba926f1f61109adb25eca28b3c721e0bbe65e47bb4b4b7d89' 
  AND token = 'DWl6LiIm/Un6K0NSAH2UIfQJwkOq9k0MLCZUW/h69Ho=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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