It looks like your overflow is in the corner.
40" would be most of not all the way over to the other side glass in a 4ft 90, why not make it so it fits snugly against the glass and use it to hold in place.
Your head pressure might build up in the tube to push it off the fitting but wouldn't that still just flow into your tank?