我能用spring boot和MySQL设置一个过期的记录时间吗？

@Entity
public class Record {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "record_time")
    private LocalDateTime recordTime;

    // getters and setters
}

public interface RecordRepository extends JpaRepository<Record, Long> {
    List<Record> findByRecordTimeBefore(LocalDateTime time);
}

@Component
public class ExpiredRecordTask {
    @Autowired
    private RecordRepository recordRepository;

    @Scheduled(fixedDelay = 86400000) // 每隔一天执行一次
    public void processExpiredRecords() {
        LocalDateTime currentTime = LocalDateTime.now();
        List<Record> expiredRecords = recordRepository.findByRecordTimeBefore(currentTime);

        // 处理过期记录，可以将其标记为过期状态或删除
    }
}