Instead of CHANGE you could also just use MODIFY I think (since we're not renaming columns):

ALTER TABLE `signup_codes` MODIFY `expires_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

The change looks good otherwise, so you can ship it after this fix (or ship directly, as this will work too.).