She asked me where I (see) myself in 30 years?
Ok, what are you fgoing to be doing in 30 years time, from now.
You are right to question, if you had a question. The one with "had" is unlikely.
What might be said is
She asked me where I had seen myself in 30 years?
So, "had" refers to a point in the past, understood by both speaker and listener(s).
So this one would need extra to make it work,
For example
I had never planned to go back to school and study after I left at a young age. Now 30 years on, things are different. I see a bright future.
She asked me where I (see) myself in 30 years. - as in previous to the change and study.
She asked me where I had seen myself in 30 years?
Had to work really hard to make that one sensible. Not likely to ever hear it.