Xinjiang is a region where wine is made. I think you may be asking about shaoxing wine. I've used it in various Chinese dishes, lion's head meatballs comes first to mind.
A dry sherry, nothing expensive, is a perfectly acceptable substitute if you want a multi cuisine wine. A dry white wine is also good, plus saki and mirin, though mirin is a bit sweet.
And, yes, it lasts a very, very long time.