The former Red Devils captain looked set to join West Ham, before the deal fell through earlier this week