What is the correct way to unpost a journal with unbalanced amount?

Hello -

We encountered a scenario where a journal with unbalanced amount is posted. We wanted to make a reversal journal by copying this journal and correct the amounts; but the original journal has a journal date and posted date outside the open period accounting, thus we can not successfully unpost this journal in Unposting page. It is not our business process to reopen a closed accounting period. Is it possible to update the journal date and posted date to current date via SQL so we can unpost this? Please advise if this is feasible.

Thanks,