Can you revise the custom melody?

Yes, as long as it's not in the manufacturing stage or approved yet.

Orders with approved melody / in the manufacturing stage can no longer be changed or canceled.