The movie was Event Horizon, http://www.imdb.com/title/tt0119081/ , which was an enjoyable watch. But that wasn't the end of it, some lyrics in that ASOT were different:
"I look back at the way I was then... I young stupid kid that committed that terrible crime. I want to talk to him, I want to try to talk some sense to him, tell him the way things are...". Oh, and at the very end of the mix:
Of course, I had heard it in other Trance mixes before, it's an awesome piano track. Interestingly, the track is called "Compass and Guns" in the movie soundtrack: https://www.youtube.com/watch?v=v04F8_sHLJk Here is the "original" trance track I had heard, which turns out was from solarstone: https://www.youtube.com/watch?v=l8hmA5ZIXDI
And I found another very nice mix done by someone else: https://www.youtube.com/watch?v=B5Rfv4b1IQA So I went from trance to movie, which then brought me back to other trance, full circle. I like how it all pieces together, thanks to a few google searches :)