Add a new option to the `add_concurrent_foreign_key` method that
explicitly locks the two tables before adding the foreign key.

The order of the explicit locking is referenced_table,
referencing_table, which is the reverse order acquired by ALTER TABLE.