No one shall see God's face until they have been judged righteous.
Matthew 5:8 Blessed are the pure in heart: for they shall see God
The King James version has the verb in the present tense but it is the LORD who is looking upon "the upright" not the upright looking upon the LORD.
Psalm 11:7 [KJV] For the righteous LORD loveth righteousness; his countenance doth behold the upright.
In modern versions, such as the RSV, the emphasis is on the future and it is the upright who will see his face, just as in Matthew 5 above.
Psalm 11:7 [RSV] For the LORD is righteous, he loves righteous deeds; the upright shall behold his face.
I hope you have found this helpful.
God bless,
Mike