More Africans believe their conditions have worsened, but are optimistic for the future