SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '23916f1e2d4903467ba0bcf0a3a25f7cfb943b7d1a7c1c9db6505b0f540aba62' 
  AND token = 'mcla5SaosYir/D5/6trp+Oal63dWb06JPNSx/7qTV/I=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00045

JSON explain

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