An absolute transaction lock
nLockTime sets the earliest height or time at which a transaction may enter a block, subject to its input sequence values. It does not stop a key holder from signing a different transaction unless the output script itself requires a lock.
CLTV locks a script branch
BIP 65 makes OP_CHECKLOCKTIMEVERIFY compare a script value with the spending transaction's nLockTime. A policy can allow joint spending now and a recovery key only after a threshold, but every alternative branch must be reviewed.
CSV measures a UTXO's age
BIP 68 gives sequence fields relative-lock meaning in version 2 or later transactions. BIP 112 lets a script require that age with CHECKSEQUENCEVERIFY, a building block used by Lightning penalty delays.
It is not an alarm clock
Blocks arrive randomly and time-based rules use median-time-past rather than one computer's clock. A timelock neither broadcasts a transaction nor provides a signature or fee; somebody must still produce a valid spend after the threshold.