UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dTlGnsqJsa4DyONKLzOxvXwnbltqNAN9DGVRkeGDeCc='
WHERE
key_id = '43ba5355ae4b694a14ec9636f928fa2c02ea30298ff0cecdf5c8244f82e27721'
AND (
token = 'dTlGnsqJsa4DyONKLzOxvXwnbltqNAN9DGVRkeGDeCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)