One "classic" presentation of metastatic bone cancer is back pain that "tends to be worse at night and may get better with movement" - American Cancer Society.
Googling "back pain worse at night from metastatic bone cancer" leads me to a case study, but I can't find a proposed mechanism for why the back pain is specifically worse at night.