"At" is the preposition we normally use to specify a time:
example: "I'll meet you at 3:00".
So, to emphasize WHEN to support him, use "at".
However, if your goal is to emphasize the duration of time during which you want to support him, use "in", "through", or "during":
"We ought to support him IN/THROUGH/DURING this difficult moment!"