Channel-Occupation-Aware Resource Allocation in LoRa Networks: a DQN-and-Optimization-Aided Approach