I've not been at GamesCom, but EvilDragon said he would have a stall there showing the last prototype devices before production (
https://pyra-handheld.com/boards/threads/open-and-close-and-... ).
The CPU board is designed to be cheaply replaceable, so you'll probably be able to buy one with a new SoC / RAM / internal storage in one or two years …